DBA Data[Home] [Help]

APPS.CSTPLCAC dependencies on WIP_OPERATION_OVERHEADS

Line 844: UPDATE wip_operation_overheads w1

840:
841:
842: l_stmt_num := 200;
843:
844: UPDATE wip_operation_overheads w1
845: SET
846: (relieved_ovhd_completion_units,
847: temp_relieved_value,
848: relieved_ovhd_completion_value) =

Line 913: wip_operation_overheads w2,

909: nvl(prior_scrap_quantity,0)),
910: 1),
911: 0)
912: FROM
913: wip_operation_overheads w2,
914: cst_comp_snapshot cocd
915: WHERE
916: w1.wip_entity_id = w2.wip_entity_id AND
917: w1.operation_seq_num = w2.operation_seq_num AND

Line 1095: WIP_OPERATION_OVERHEADS

1091: i_prog_appl_id,
1092: i_prog_id,
1093: SYSDATE
1094: FROM
1095: WIP_OPERATION_OVERHEADS
1096: WHERE
1097: WIP_ENTITY_ID = i_wip_entity_id AND
1098: ORGANIZATION_ID = i_org_id
1099: HAVING

Line 1809: UPDATE wip_operation_overheads w1

1805:
1806:
1807: l_stmt_num := 130;
1808:
1809: UPDATE wip_operation_overheads w1
1810: SET
1811: (relieved_ovhd_completion_units,
1812: temp_relieved_value,
1813: relieved_ovhd_completion_value) =

Line 1850: wip_operation_overheads w2,

1846: prior_completion_quantity)),
1847: 0)
1848:
1849: FROM
1850: wip_operation_overheads w2,
1851: cst_comp_snapshot cocd
1852: WHERE
1853: w2.wip_entity_id = w1.wip_entity_id AND
1854: w2.organization_id = w1.organization_id AND

Line 2021: WIP_OPERATION_OVERHEADS

2017: i_prog_appl_id,
2018: i_prog_id,
2019: SYSDATE
2020: FROM
2021: WIP_OPERATION_OVERHEADS
2022: WHERE
2023: WIP_ENTITY_ID = i_wip_entity_id AND
2024: ORGANIZATION_ID = i_org_id
2025: HAVING