DBA Data[Home] [Help]

APPS.INVIDIT3 dependencies on CST_QUANTITY_LAYERS

Line 1334: from cst_quantity_layers

1330: if (cost_moq <> 1 and cost_tmp <> 1 AND cost_mmt <> 1) then
1331:
1332: select count(1)
1333: into cost_cst
1334: from cst_quantity_layers
1335: where inventory_item_id = p_item_id
1336: and organization_id = p_org_id
1337: and layer_quantity <> 0
1338: and exists (select 1

Line 1350: from cst_quantity_layers

1346: if (cost_moq <> 1 and cost_moq2 <> 2 and cost_tmp <> 1 AND cost_mmt <> 1 AND cost_tmp2 <> 2 AND cost_cst <> 1) then
1347:
1348: select count(1)
1349: into cost_cst2
1350: from cst_quantity_layers
1351: where inventory_item_id = p_item_id
1352: and layer_quantity <> 0
1353: and organization_id in
1354: (select organization_id