APPS.GMF_LAYERS dependencies on GME_RESOURCE_TXNS

Line 700: p_rsrc_rec IN gme_resource_txns%ROWTYPE,

696: */
697: PROCEDURE Create_Resource_Layers
698: ( p_api_version IN NUMBER,
699: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
700: p_rsrc_rec IN gme_resource_txns%ROWTYPE,
701: p_doc_qty IN NUMBER,
702: p_doc_um IN VARCHAR2,
703: x_return_status OUT NOCOPY VARCHAR2,
704: x_msg_count OUT NOCOPY NUMBER,

Line 1118: FROM gme_batch_header h, gme_resource_txns t

1114: DELETE
1115: FROM gmf_resource_layers il
1116: WHERE il.poc_trans_id IN
1117: (SELECT t.poc_trans_id
1118: FROM gme_batch_header h, gme_resource_txns t
1119: WHERE h.batch_id = p_batch_id
1120: AND h.batch_id = t.doc_id
1121: AND t.doc_type = 'PROD'
1122: );

Line 1304: FROM gme_batch_header h, gme_resource_txns t

1300: DELETE
1301: FROM gmf_resource_layers il
1302: WHERE il.poc_trans_id IN
1303: (SELECT t.poc_trans_id
1304: FROM gme_batch_header h, gme_resource_txns t
1305: WHERE h.batch_id = p_batch_id
1306: AND h.batch_id = t.doc_id
1307: AND t.doc_type = 'PROD'
1308: AND t.trans_date >= l_start_date

Line 1435: rt gme_resource_txns%ROWTYPE;

1431: );
1432:
1433:
1434: mt mtl_material_transactions%ROWTYPE;
1435: rt gme_resource_txns%ROWTYPE;
1436: l_lot_number VARCHAR2(100);
1437:
1438: x_return_status VARCHAR2(10);
1439: x_msg_count NUMBER;

Line 1669: FROM gme_resource_txns rt, gme_batch_header b

1665: select *
1666: from
1667: ( SELECT rt.rowid r_id, rt.poc_trans_id as trans_id, rt.trans_date, rt.line_type as line_type, rt.trans_qty_um as doc_um, 'R' as type,
1668: rt.resource_usage as trans_qty, rt.reverse_id
1669: FROM gme_resource_txns rt, gme_batch_header b
1670: WHERE rt.doc_type = 'PROD'
1671: AND rt.doc_id = b.batch_id
1672: AND rt.completed_ind = 1
1673: AND rt.delete_mark = 0

Line 1693: rt gme_resource_txns%ROWTYPE;

1689: trans_id
1690: );
1691:
1692: mt mtl_material_transactions%ROWTYPE;
1693: rt gme_resource_txns%ROWTYPE;
1694: l_lot_number VARCHAR2(100);
1695:
1696: x_return_status VARCHAR2(10);
1697: x_msg_count NUMBER;

Line 1745: FROM gme_resource_txns

1741:
1742: fnd_msg_pub.initialize;
1743:
1744: SELECT * INTO rt
1745: FROM gme_resource_txns
1746: WHERE
1747: ROWID = t.r_id;
1748:
1749: SELECT count(*)

Line 1880: rt gme_resource_txns%ROWTYPE;

1876:
1877:
1878:
1879: mt mtl_material_transactions%ROWTYPE;
1880: rt gme_resource_txns%ROWTYPE;
1881: l_lot_number VARCHAR2(100);
1882:
1883: x_return_status VARCHAR2(10);
1884: x_msg_count NUMBER;

Line 2397: gme_resource_txns r

2393: UNION
2394: SELECT h.batch_id, h.batch_no, h.batch_status , h.actual_start_date asd,
2395: h.batch_close_date, h.organization_id
2396: FROM gme_batch_header h,
2397: gme_resource_txns r
2398: WHERE h.batch_status in (2,3,4) -- B9441550
2399: AND h.actual_start_date <= l_enddate
2400: AND h.batch_id = r.doc_id
2401: AND r.trans_date >= l_startdate

Line 2449: gme_resource_txns r

2445: UNION
2446: SELECT h.batch_id, h.batch_no, h.batch_status , h.actual_start_date asd,
2447: h.batch_close_date, h.organization_id
2448: FROM gme_batch_header h,
2449: gme_resource_txns r
2450: WHERE h.batch_status in (2,3,4) -- B9441550
2451: AND h.actual_start_date <= l_enddate
2452: AND h.batch_id = r.doc_id
2453: AND r.trans_date >= l_startdate

Line 2502: gme_resource_txns r

2498: UNION
2499: SELECT h.batch_id, h.batch_no, h.batch_status , h.actual_start_date asd,
2500: h.batch_close_date, h.organization_id
2501: FROM gme_batch_header h,
2502: gme_resource_txns r
2503: WHERE h.batch_status in (2,3,4) -- B9441550
2504: AND h.actual_start_date <= l_enddate
2505: AND h.batch_id = r.doc_id
2506: AND r.trans_date >= l_startdate