Sorry, I didn't include any sample data. I think this should do it.

Insert tblFILE (FileNumber, Status) Values(10111, 'O')
Insert tblFILE (FileNumber, Status) Values(10222, 'O')
Insert tblFile (FileNumber, Status) values(10333, 'X')
Insert tblFILe (FileNumber, Status) Values(10444, 'O')

Insert tblBL (bl_Identity, bl, FileNumber) values(200, 'bl1', 10222)
Insert tblBL (bl_Identity, bl, FileNumber) values(210, 'bl2', 10111)
Insert tblBL (bl_Identity, bl, FileNumber) values(220, 'bl2', 10111)

Insert tblCONTAINER (ContainerID, ContainerNumber) Values(30,
C10000000)
Insert tblCONTAINER (ContainerID, ContainerNumber) Values(31,
C11111111)
Insert tblCONTAINER (ContainerID, ContainerNumber) Values(32,
C12222222)
Insert tblCONTAINER (ContainerID, ContainerNumber) Values(33,
C13333333)
Insert tblCONTAINER (ContainerID, ContainerNumber) Values(34,
C14444444)
Insert tblCONTAINER (ContainerID, ContainerNumber) Values(35,
C15555555)
Insert tblCONTAINER (ContainerID, ContainerNumber) Values(36,
C16666666)

Insert tblCONTAINER_BL (ContainerID, BL_Identity) Values(30, 200)
Insert tblCONTAINER_BL (ContainerID, BL_Identity) values(31, 200)
Insert tblCONTAINER_BL (ContainerID, BL_Identity) values(32, 220)

Insert tblHBL (hbl_Identity, hbl, FileNumber, bl_Identity) values(400,
'hbl1', 10222, NULL)
Insert tblHBL (hbl_Identity, hbl, FileNumber, bl_Identity) values(410,
'hbl2', 10111, 210)
Insert tblHBL (hbl_Identity, hbl, FileNumber, bl_Identity) values(420,
'hbl3', 10444, NULL)
Insert tblHBL (hbl_Identity, hbl, FileNumber, bl_Identity) values(430,
'hbl4', 10111, 210)

Insert tblCONTAINER_HBL (ContainerID, hbl_Identity) values(33, 400)
Insert tblCONTAINER_HBL (ContainerID, hbl_Identity) values(34, 400)
Insert tblCONTAINER_HBL (ContainerID, hbl_Identity) values(35, 400)
Insert tblCONTAINER_HBL (ContainerID, hbl_Identity) values(36, 430)