eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOMPASGR dependencies on STANDARD

Line 845: operation_code SOC, standard_operation_id SOI,

841: operation_sequence_id OSI,
842: assembly_item_id AII, assembly_item_number AIN,
843: alternate_routing_designator ARD, routing_sequence_id RSI,
844: department_id DI, department_code DC,
845: operation_code SOC, standard_operation_id SOI,
846: transaction_id TI, operation_seq_num OSN,
847: to_char(effectivity_date,'YYYY/MM/DD HH24:MI:SS') ED, -- Changed for bug 2647027
848: -- to_char(effectivity_date,'YYYY/MM/DD HH24:MI') ED,
849: minimum_transfer_quantity MTQ, count_point_type CPT,

Line 1090: ** Set standard operation values as defaults

1086: end if;
1087: end if;
1088:
1089: /*
1090: ** Set standard operation values as defaults
1091: */
1092: stmt_num := 6;
1093: if (c1rec.SOI is not null) then
1094: begin

Line 1107: from bom_standard_operations

1103: std_bkflsh, std_opt, std_attcat, std_att1, std_att2,
1104: std_att3, std_att4, std_att5, std_att6, std_att7,
1105: std_att8, std_att9, std_att10, std_att11, std_att12,
1106: std_att13, std_att14, std_att15
1107: from bom_standard_operations
1108: where organization_id = c1rec.OI
1109: and standard_operation_id = c1rec.SOI;
1110: exception
1111: when NO_DATA_FOUND then

Line 1109: and standard_operation_id = c1rec.SOI;

1105: std_att8, std_att9, std_att10, std_att11, std_att12,
1106: std_att13, std_att14, std_att15
1107: from bom_standard_operations
1108: where organization_id = c1rec.OI
1109: and standard_operation_id = c1rec.SOI;
1110: exception
1111: when NO_DATA_FOUND then
1112: ret_code := INVPUOPI.mtl_log_interface_err(
1113: org_id => c1rec.OI,

Line 1231: standard_operation_id = nvl(standard_operation_id,c1rec.SOI),

1227: department_id = nvl(department_id, c1rec.DI),
1228: organization_id = nvl(organization_id, c1rec.OI),
1229: assembly_item_id = nvl(assembly_item_id, c1rec.AII),
1230: process_flag = 2,
1231: standard_operation_id = nvl(standard_operation_id,c1rec.SOI),
1232: routing_sequence_id = nvl(routing_sequence_id, c1rec.RSI),
1233: operation_sequence_id = nvl(operation_sequence_id, c1rec.OSI),
1234: last_update_date = nvl(last_update_date, sysdate),
1235: last_updated_by = nvl(last_updated_by, user_id),

Line 1273: ** assign resources for standard operation

1269: err_text := substrb('BOMPASGR(bmasopd-' || stmt_num || ') ' || SQLERRM,1,240);
1270: return(SQLCODE);
1271: end if;
1272: /*
1273: ** assign resources for standard operation
1274: */
1275: if (c1rec.SOI is not null) then
1276: insert into bom_op_resources_interface (
1277: OPERATION_SEQUENCE_ID,

Line 1281: STANDARD_RATE_FLAG,

1277: OPERATION_SEQUENCE_ID,
1278: RESOURCE_SEQ_NUM,
1279: RESOURCE_ID,
1280: ACTIVITY_ID,
1281: STANDARD_RATE_FLAG,
1282: ASSIGNED_UNITS,
1283: USAGE_RATE_OR_AMOUNT,
1284: USAGE_RATE_OR_AMOUNT_INVERSE,
1285: BASIS_TYPE,

Line 1320: STANDARD_RATE_FLAG,

1316: c1rec.OSI,
1317: RESOURCE_SEQ_NUM,
1318: RESOURCE_ID,
1319: ACTIVITY_ID,
1320: STANDARD_RATE_FLAG,
1321: ASSIGNED_UNITS,
1322: USAGE_RATE_OR_AMOUNT,
1323: USAGE_RATE_OR_AMOUNT_INVERSE,
1324: BASIS_TYPE,

Line 1356: where standard_operation_id = c1rec.SOI;

1352: NULL,
1353: NULL,
1354: 1
1355: from bom_std_op_resources
1356: where standard_operation_id = c1rec.SOI;
1357:
1358: end if;
1359:
1360: /*

Line 1456: basis_type BT, autocharge_type AUT, standard_rate_flag SRF

1452: select transaction_id TI, organization_id OI,
1453: operation_sequence_id OSI, resource_id RI, resource_code RC,
1454: activity_id AI, activity A, usage_rate_or_amount URA,
1455: usage_rate_or_amount_inverse URAI, assigned_units AU,
1456: basis_type BT, autocharge_type AUT, standard_rate_flag SRF
1457: from bom_op_Resources_interface
1458: where process_flag = 1
1459: and operation_sequence_id is not null
1460: and (all_org = 1

Line 2006: nvl(c2rec.SRF, standard_rate_flag)

2002: nvl(c2rec.AI, default_activity_id),
2003: nvl(c2rec.AUT,decode(dummy_loc, NULL,
2004: decode(AUTOCHARGE_TYPE, NULL, 2, 3, 2, 4, 2,
2005: AUTOCHARGE_TYPE), nvl(AUTOCHARGE_TYPE, 2))),
2006: nvl(c2rec.SRF, standard_rate_flag)
2007: into c2rec.BT, c2rec.AI, c2rec.AUT, c2rec.SRF
2008: from bom_resources
2009: where resource_id = c2rec.RI;
2010:

Line 2018: STANDARD_RATE_FLAG = nvl(c2rec.SRF, 1),

2014: organization_id = c2rec.OI,
2015: BASIS_TYPE = nvl(c2rec.BT,1),
2016: AUTOCHARGE_TYPE = c2rec.AUT,
2017: ACTIVITY_ID = c2rec.AI,
2018: STANDARD_RATE_FLAG = nvl(c2rec.SRF, 1),
2019: ASSIGNED_UNITS = c2rec.AU,
2020: USAGE_RATE_OR_AMOUNT = nvl(c2rec.URA,1),
2021: USAGE_RATE_OR_AMOUNT_INVERSE = nvl(c2rec.URAI,1),
2022: SCHEDULE_FLAG = nvl(schedule_flag, 2),

Line 2492: select standard_operation_id

2488: return INTEGER
2489: IS
2490:
2491: BEGIN
2492: select standard_operation_id
2493: into stdop_id
2494: from bom_Standard_operations
2495: where organization_id = org_id
2496: and operation_code = stdop_code;

Line 2494: from bom_Standard_operations

2490:
2491: BEGIN
2492: select standard_operation_id
2493: into stdop_id
2494: from bom_Standard_operations
2495: where organization_id = org_id
2496: and operation_code = stdop_code;
2497: return(0);
2498: EXCEPTION