[Home] [Help]
632: FROM
633: bom_operational_routings bor
634: WHERE
635: bor.routing_sequence_id = from_sequence_id;
636: INSERT INTO mtl_interface_errors
637: (unique_id,
638: organization_id,
639: transaction_id,
640: table_name,
785: AND bos.acd_type = 3
786: AND bos.effectivity_date <= p_trgt_eff_date
787: AND bos.implementation_date IS NULL
788: );
789: INSERT INTO mtl_interface_errors
790: (unique_id,
791: organization_id,
792: transaction_id,
793: table_name,
863: AND bos.acd_type = 3
864: AND bos.effectivity_date <= p_trgt_eff_date
865: AND bos.implementation_date IS NULL
866: );
867: INSERT INTO mtl_interface_errors
868: (unique_id,
869: organization_id,
870: transaction_id,
871: table_name,
1180: */
1181: AND NVL (bos4.operation_type, 1) = NVL (bos2.operation_type, 1);
1182:
1183: IF p_log_errors = 'Y' THEN
1184: INSERT INTO mtl_interface_errors
1185: (unique_id,
1186: organization_id,
1187: transaction_id,
1188: table_name,
1281: AND bos4.operation_seq_num = bos2.operation_seq_num
1282: AND NVL (bos4.operation_type, 1) = NVL (bos2.operation_type, 1)
1283: AND mfgl.lookup_type = 'BOM_OPERATION_TYPE'
1284: AND mfgl.lookup_code = bos1.operation_type;
1285: INSERT INTO mtl_interface_errors
1286: (unique_id,
1287: organization_id,
1288: transaction_id,
1289: table_name,
1554: -- AND E.DEPARTMENT_ID = A.DEPARTMENT_ID
1555: AND NVL (d.disable_date, SYSDATE + 1) > SYSDATE;
1556:
1557: IF p_log_errors = 'Y' THEN
1558: INSERT INTO mtl_interface_errors
1559: (unique_id,
1560: organization_id,
1561: transaction_id,
1562: table_name,
1797: AND d.organization_id = to_org_id
1798: AND NVL (d.disable_date, SYSDATE + 1) > SYSDATE;
1799:
1800: IF p_log_errors = 'Y' THEN
1801: INSERT INTO mtl_interface_errors
1802: (unique_id,
1803: organization_id,
1804: transaction_id,
1805: table_name,
2593: FROM
2594: bom_operational_routings bor
2595: WHERE
2596: bor.routing_sequence_id = from_sequence_id;
2597: INSERT INTO mtl_interface_errors
2598: (unique_id,
2599: organization_id,
2600: transaction_id,
2601: table_name,
2701: AND bos.acd_type = 3
2702: AND bos.effectivity_date <= p_eco_eff_date
2703: AND bos.implementation_date IS NULL
2704: );
2705: INSERT INTO mtl_interface_errors
2706: (unique_id,
2707: organization_id,
2708: transaction_id,
2709: table_name,
2760: AND bos.effectivity_date <= p_eco_eff_date
2761: AND bos.implementation_date IS NULL
2762: );
2763:
2764: INSERT INTO mtl_interface_errors
2765: (unique_id,
2766: organization_id,
2767: transaction_id,
2768: table_name,
3058: AND NVL (bos4.operation_type, 1) = NVL (bos2.operation_type, 1)
3059: AND bos2.revised_item_sequence_id = p_rev_item_seq_id;
3060:
3061: IF p_log_errors = 'Y' THEN
3062: INSERT INTO mtl_interface_errors
3063: (unique_id,
3064: organization_id,
3065: transaction_id,
3066: table_name,
3161: AND NVL (bos4.operation_type, 1) = NVL (bos2.operation_type, 1)
3162: AND mfgl.lookup_type = 'BOM_OPERATION_TYPE'
3163: AND mfgl.lookup_code = bos1.operation_type
3164: AND bos2.revised_item_sequence_id = p_rev_item_seq_id;
3165: INSERT INTO mtl_interface_errors
3166: (unique_id,
3167: organization_id,
3168: transaction_id,
3169: table_name,
3384: AND NVL (d.disable_date, SYSDATE + 1) > SYSDATE
3385: AND a.revised_item_sequence_id = p_rev_item_seq_id;
3386:
3387: IF p_log_errors = 'Y' THEN
3388: INSERT INTO mtl_interface_errors
3389: (unique_id,
3390: organization_id,
3391: transaction_id,
3392: table_name,
3629: AND d.organization_id = to_org_id
3630: AND NVL (d.disable_date, SYSDATE + 1) > SYSDATE;
3631:
3632: IF p_log_errors = 'Y' THEN
3633: INSERT INTO mtl_interface_errors
3634: (unique_id,
3635: organization_id,
3636: transaction_id,
3637: table_name,